Streams AQ: qmn coordinator idle wait
Short Description
Idle event. Oracle Streams Advances Queuing co-ordinator is waiting to assign work to slaves.
Disclaimer​
The terms master and slave have historically been used by vendors in database wait events. DBmarlin does not support or condone the use of these terms. As vendors remove these terms from their software, occurrences will reduce.
Detailed Description​
Undocumented idle event. Oracle Streams Advances Queuing co-ordinator is waiting to assign work to workers.
How to reduce this wait​
Oracle Streams was deprecated in 12.1 and does not appear in Oracle Database 19 onwards.
Additional Links​
Oracle Streams Deprecation Notice
Search online​
If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.